{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Macros","Regulation 28 calculator (%)","Limits","Regulation 28 calculator (rand)","Allocation","Allocation (rand)","Unit trust asset class limits","Fund list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Macros","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[[5,11,6,11],[10,6,12,11],[14,6,19,10],[14,11,19,11],[22,2,22,4],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[37,2,44,4],[46,2,47,4],[1,2,1,5],[27,2,27,3],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[33,2,34,4],[24,2,24,4]]}
[]
[null,null,"Please enable macros"]
[]
[null,null,"1.  Excel 2007:  Click the Microsoft Office Button            , and then click Excel Options."]
[null,null,"1.  Excel 2010:  Click the File tab, and then click Options."]
[]
[null,null,"2. In the Trust Centre category, click Trust Centre Settings, and then click the Macro Settings category."]
[]
[null,null,"3. Select Enable all macros and click OK."]
[]
[null,null,"4. Close the Excel Options window."]
[]
[null,null,"5. Close and re-open the Regulation 28 Calculator."]

{"sheet":"Regulation 28 calculator (%)","index":1,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,2,47,4],[33,2,34,4],[28,2,28,4],[30,2,30,4],[31,2,31,4],[29,2,29,4],[21,2,21,4],[23,2,23,4],[24,2,24,4],[27,2,27,3],[37,2,44,4],[14,11,19,11],[3,3,3,4],[5,11,6,11],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[10,6,12,11],[14,6,19,10]]}
[]
[null,null,"Regulation 28 investment compliance calculator "]
[]
[null,null,"Total amount"]
[]
[null,null,"Unit trust name","Amount","%",null,"Exposure","Regulation 28 limit","Investment exposure","Regulation 28 compliant","% over limit","Rand amount over limit"]
[null,{"$f":"IF(C7<>\"\",_xlfn.IFNA(VLOOKUP(C7,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,{"$f":"IF(AND(E7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(E7)),E7*Total,\"\")","v":""}]
[null,{"$f":"IF(C8<>\"\",_xlfn.IFNA(VLOOKUP(C8,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Equity",0.75,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G8,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,I8-H8,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I8-H8>0.00004999,K8*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C9<>\"\",_xlfn.IFNA(VLOOKUP(C9,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Foreign",0.45,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G9,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,I9-H9,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I9-H9>0.00004999,K9*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C10<>\"\",_xlfn.IFNA(VLOOKUP(C10,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),_xlfn.IFNA(ROUND(HLOOKUP(G10,Allocation!$B$1:$D$17,MATCH(\"Total\",Allocation!A:A,0),FALSE),4),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,I10-H10,\"\"),\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0),IFERROR(IF(I10-H10>0.00004999,K10*Total,\"\"),\"\"),\"\")","v":""}]
[null,{"$f":"IF(C11<>\"\",_xlfn.IFNA(VLOOKUP(C11,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C12<>\"\",_xlfn.IFNA(VLOOKUP(C12,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C13<>\"\",_xlfn.IFNA(VLOOKUP(C13,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C14<>\"\",_xlfn.IFNA(VLOOKUP(C14,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C15<>\"\",_xlfn.IFNA(VLOOKUP(C15,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,"",null,null,"Is the portfolio compliant with Regulation 28 of the Pension Funds Act?",null,null,null,null,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,C23=\"\"),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,{"$f":"IF(C16<>\"\",_xlfn.IFNA(VLOOKUP(C16,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C17<>\"\",_xlfn.IFNA(VLOOKUP(C17,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C18<>\"\",_xlfn.IFNA(VLOOKUP(C18,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C19<>\"\",_xlfn.IFNA(VLOOKUP(C19,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,{"$f":"IF(C20<>\"\",_xlfn.IFNA(VLOOKUP(C20,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,""]
[null,null,"Total",{"$f":"IF(ISERROR(SUM(AmountColumn)),\"Error\",SUM(AmountColumn))","v":0},{"$f":"IF(ISERROR(SUM(PercentColumn)),\"Error\",SUM(PercentColumn))","v":0}]
[]
[null,null,{"$f":"IF(AND(AND($E$21<>1,$D$4>0),OR(B7:B20)),\"Please ensure that your fund selection sums to 100% and only includes funds from the fund list.\",IF(OR(B7:B20),\"Please ensure that your fund selection only includes funds from the fund list.\",IF(AND($E$21<>1,$D$4>0),\"Please ensure that your fund selection sums to 100%.\",\"\")))","v":""}]
[]
[null,null,"If you would like to enter a rand amount instead of a percentage amount, please click the ‘Regulation 28 calculator (rand)’ tab at the bottom of the page."]
[]
[null,null,"How to use the Regulation 28 calculator"]
[null,null,"(Please ensure that your Calculation Options are set to Automatic)"]
[null,"• ","Enter the total rand amount of your investment in the ‘total amount’ section."]
[null,"• ","Choose your unit trust selection from the drop-down box in the ‘unit trust name’ column."]
[null,"• ","Enter the percentage of the total amount that you would like to allocate to each unit trust in the ‘%’ column."]
[null,"• ","The ‘amount’ column will automatically update based on the information entered in the ‘total amount’ and ‘%’ columns."]
[]
[null,null,"Click on the 'Unit trust asset class limits' tab at the bottom to view the Regulation 28 asset class limits of your selected unit trusts."]
[]
[]
[null,null,"Regulation 28 limits "]
[null,null,"Once your investment total adds up to 100%, your investment’s exposure to each asset class (asset allocation) will be shown under the ‘asset class’ section on the \nright-hand side of the page.\n\nYour asset allocation will then be compared to the prescribed limits of Regulation 28. If your asset allocation meets these limits, the calculator will indicate this with a ‘Yes’ on the right-hand side of the page. If your investment does not meet the prescribed limits, the calculator will indicate this with a ‘No’, and display the areas where your investment does not comply."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2025-04-25T08:38:02"]

{"sheet":"Limits","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Code","ReportingDescription","Limit",null,"Last update notice","2022-02-28"]
["equity","Equity",0.75]
["offshore","Offshore",0.45]
["prop","Property",0.25]

{"sheet":"Regulation 28 calculator (rand)","index":3,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,3,3,4],[5,6,6,6],[5,11,6,11],[10,6,12,11],[14,6,19,10],[14,11,19,11],[5,9,6,9],[5,10,6,10],[5,8,6,8],[31,2,31,4],[33,2,34,4],[46,2,47,4],[37,2,44,4],[5,7,6,7],[29,2,29,4],[30,2,30,4],[28,2,28,4],[24,2,24,4],[27,2,27,3]]}
[]
[null,null,"Regulation 28 investment compliance calculator ",null,null,null,null,null,null,null,null,{"$f":"'Regulation 28 calculator (%)'!L2","v":0}]
[]
[null,null,"Total amount"]
[]
[null,null,"Unit trust name","Amount","%",null,"Exposure","Regulation 28 limit","Investment exposure","Regulation 28 compliant","% over limit","Rand amount over limit"]
[null,{"$f":"IF(C7<>\"\",_xlfn.IFNA(VLOOKUP(C7,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,{"$f":"IF(AND(D7>0,C7<>\"\",ISNUMBER(Total),ISNUMBER(D7)),D7/Total,\"\")","v":""}]
[null,{"$f":"IF(C8<>\"\",_xlfn.IFNA(VLOOKUP(C8,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,{"$f":"IF(AND(D8>0,C8<>\"\",ISNUMBER(Total),ISNUMBER(D8)),D8/Total,\"\")","v":""},null,"Equity",0.75,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G8,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,I8-H8,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I8-H8>0.00004999,K8*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C9<>\"\",_xlfn.IFNA(VLOOKUP(C9,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Foreign",0.45,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G9,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,I9-H9,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I9-H9>0.00004999,K9*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C10<>\"\",_xlfn.IFNA(VLOOKUP(C10,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Property",0.25,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),ROUND(HLOOKUP(G10,'Allocation (rand)'!$B$1:$D$17,MATCH(\"Total\",'Allocation (rand)'!A:A,0),FALSE),4),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,\"No\",\"Yes\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,I10-H10,\"\"),\"\")","v":""},{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,$C$23=\"\"),IF(I10-H10>0.00004999,K10*Total,\"\"),\"\")","v":""}]
[null,{"$f":"IF(C11<>\"\",_xlfn.IFNA(VLOOKUP(C11,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C12<>\"\",_xlfn.IFNA(VLOOKUP(C12,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C13<>\"\",_xlfn.IFNA(VLOOKUP(C13,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C14<>\"\",_xlfn.IFNA(VLOOKUP(C14,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C15<>\"\",_xlfn.IFNA(VLOOKUP(C15,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,"",null,"Is the portfolio compliant with Regulation 28 of the Pension Funds Act?",null,null,null,null,{"$f":"IF(AND(AreaPercent=1,Total=AreaTotal,Total<>\"\",Total>0,C23=\"\"),IF(ABS(SUM(K8:K10)-0)>0.0001,\"No\",\"Yes\"),\"\")","v":""}]
[null,{"$f":"IF(C16<>\"\",_xlfn.IFNA(VLOOKUP(C16,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C17<>\"\",_xlfn.IFNA(VLOOKUP(C17,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C18<>\"\",_xlfn.IFNA(VLOOKUP(C18,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C19<>\"\",_xlfn.IFNA(VLOOKUP(C19,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,{"$f":"IF(C20<>\"\",_xlfn.IFNA(VLOOKUP(C20,'Fund list'!$A:$A,1,FALSE),-1)=-1,FALSE)","v":false},null,null,""]
[null,null,"Total",{"$f":"IF(ISERROR(SUM(AmountColumn)),\"Error\",SUM(AmountColumn))","v":0},{"$f":"IF(ISERROR(SUM(PercentColumn)),\"Error\",SUM(PercentColumn))","v":0}]
[]
[null,null,{"$f":"IF(AND(AND($E$21<>1,$D$4>0),OR(B7:B20)),\"Please ensure that your fund selection sums to 100% and only includes funds from the fund list.\",IF(OR(B7:B20),\"Please ensure that your fund selection only includes funds from the fund list.\",IF(AND($E$21<>1,$D$4>0),\"Please ensure that your fund selection sums to 100%.\",\"\")))","v":""}]
[]
[null,null,"If you would like to enter a percentage amount instead of a rand amount, please click the ‘Regulation 28 calculator (%)’ tab at the bottom of the page."]
[]
[null,null,"How to use the Regulation 28 calculator"]
[null,null,"(Please ensure that your Calculation Options are set to Automatic)"]
[null,"• ","Enter the total rand amount of your investment in the ‘total amount’ section."]
[null,"• ","Choose your unit trust selection from the drop-down box in the ‘unit trust name’ column."]
[null,"• ","Enter the rand value that you would like to allocate to each unit trust in the ‘amount’ column."]
[null,"• ","The ‘%’ column will automatically update based on the information entered in the ‘total amount’ and ‘amount’ columns."]
[]
[null,null,"Click on the 'Unit trust asset class limits' tab at the bottom to view the Regulation 28 asset class limits of your selected unit trusts."]
[]
[]
[null,null,"Regulation 28 limits "]
[null,null,"Once your investment total adds up to 100%, your investment’s exposure to each asset class (asset allocation) will be shown under the ‘asset class’ section on the \nright-hand side of the page.\n\nYour asset allocation will then be compared to the prescribed limits of Regulation 28. If your asset allocation meets these limits, the calculator will indicate this with a ‘Yes’ on the right-hand side of the page. If your investment does not meet the prescribed limits, the calculator will indicate this with a ‘No’, and display the areas where your investment does not comply.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2025-04-25T08:38:02"]

{"sheet":"Allocation","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Display name","Equity","Foreign","Property"]
["fund","equity","offshore","prop"]
[{"$f":"IF('Regulation 28 calculator (%)'!C7>\"\",'Regulation 28 calculator (%)'!C7,\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (%)'!$C7:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C8>\"\",'Regulation 28 calculator (%)'!C8,\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (%)'!$C8:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C9>\"\",'Regulation 28 calculator (%)'!C9,\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (%)'!$C9:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C10>\"\",'Regulation 28 calculator (%)'!C10,\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (%)'!$C10:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C11>\"\",'Regulation 28 calculator (%)'!C11,\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (%)'!$C11:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C12>\"\",'Regulation 28 calculator (%)'!C12,\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (%)'!$C12:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C13>\"\",'Regulation 28 calculator (%)'!C13,\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (%)'!$C13:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C14>\"\",'Regulation 28 calculator (%)'!C14,\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (%)'!$C14:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C15>\"\",'Regulation 28 calculator (%)'!C15,\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (%)'!$C15:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C16>\"\",'Regulation 28 calculator (%)'!C16,\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (%)'!$C16:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C17>\"\",'Regulation 28 calculator (%)'!C17,\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (%)'!$C17:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C18>\"\",'Regulation 28 calculator (%)'!C18,\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (%)'!$C18:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C19>\"\",'Regulation 28 calculator (%)'!C19,\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (%)'!$C19:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (%)'!C20>\"\",'Regulation 28 calculator (%)'!C20,\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH(Allocation!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (%)'!$C20:$E$20,3,FALSE),\"\")","v":""}]
["Total",{"$f":"SUM(B3:B16)","v":0},{"$f":"SUM(C3:C16)","v":0},{"$f":"SUM(D3:D16)","v":0}]

{"sheet":"Allocation (rand)","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Display name","Equity","Foreign","Property"]
["fund","equity","offshore","prop"]
[{"$f":"IF('Regulation 28 calculator (rand)'!C7>\"\",'Regulation 28 calculator (rand)'!C7,\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A3<>\"\",VLOOKUP($A3,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A3,'Regulation 28 calculator (rand)'!$C7:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C8>\"\",'Regulation 28 calculator (rand)'!C8,\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A4<>\"\",VLOOKUP($A4,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A4,'Regulation 28 calculator (rand)'!$C8:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C9>\"\",'Regulation 28 calculator (rand)'!C9,\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A5<>\"\",VLOOKUP($A5,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A5,'Regulation 28 calculator (rand)'!$C9:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C10>\"\",'Regulation 28 calculator (rand)'!C10,\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A6<>\"\",VLOOKUP($A6,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A6,'Regulation 28 calculator (rand)'!$C10:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C11>\"\",'Regulation 28 calculator (rand)'!C11,\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A7<>\"\",VLOOKUP($A7,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A7,'Regulation 28 calculator (rand)'!$C11:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C12>\"\",'Regulation 28 calculator (rand)'!C12,\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP($A8,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A8,'Regulation 28 calculator (rand)'!$C12:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C13>\"\",'Regulation 28 calculator (rand)'!C13,\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP($A9,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A9,'Regulation 28 calculator (rand)'!$C13:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C14>\"\",'Regulation 28 calculator (rand)'!C14,\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP($A10,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A10,'Regulation 28 calculator (rand)'!$C14:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C15>\"\",'Regulation 28 calculator (rand)'!C15,\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP($A11,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A11,'Regulation 28 calculator (rand)'!$C15:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C16>\"\",'Regulation 28 calculator (rand)'!C16,\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP($A12,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A12,'Regulation 28 calculator (rand)'!$C16:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C17>\"\",'Regulation 28 calculator (rand)'!C17,\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP($A13,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A13,'Regulation 28 calculator (rand)'!$C17:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C18>\"\",'Regulation 28 calculator (rand)'!C18,\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP($A14,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A14,'Regulation 28 calculator (rand)'!$C18:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C19>\"\",'Regulation 28 calculator (rand)'!C19,\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP($A15,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A15,'Regulation 28 calculator (rand)'!$C19:$E$20,3,FALSE),\"\")","v":""}]
[{"$f":"IF('Regulation 28 calculator (rand)'!C20>\"\",'Regulation 28 calculator (rand)'!C20,\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!B$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!C$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP($A16,'Fund list'!A:J,MATCH('Allocation (rand)'!D$1,'Fund list'!A$5:J$5,0),FALSE)*VLOOKUP($A16,'Regulation 28 calculator (rand)'!$C20:$E$20,3,FALSE),\"\")","v":""}]
["Total",{"$f":"SUM(B3:B16)","v":0},{"$f":"SUM(C3:C16)","v":0},{"$f":"SUM(D3:D16)","v":0}]

{"sheet":"Unit trust asset class limits","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,4,2,6],[24,2,24,5],[19,2,20,4]]}
[]
[null,null,"Regulation 28 asset class limits",{"$f":"IF(CONCATENATE('Regulation 28 calculator (%)'!C7,'Regulation 28 calculator (%)'!C8,'Regulation 28 calculator (%)'!C9,'Regulation 28 calculator (%)'!C10,'Regulation 28 calculator (%)'!C11,'Regulation 28 calculator (%)'!C12,'Regulation 28 calculator (%)'!C13,'Regulation 28 calculator (%)'!C14,'Regulation 28 calculator (%)'!C15,'Regulation 28 calculator (%)'!C16,'Regulation 28 calculator (%)'!C17,'Regulation 28 calculator (%)'!C18,'Regulation 28 calculator (%)'!C19,'Regulation 28 calculator (%)'!C20)>\"\",\"percent\",IF(CONCATENATE('Regulation 28 calculator (rand)'!C7,'Regulation 28 calculator (rand)'!C8,'Regulation 28 calculator (rand)'!C9,'Regulation 28 calculator (rand)'!C10,'Regulation 28 calculator (rand)'!C11,'Regulation 28 calculator (rand)'!C12,'Regulation 28 calculator (rand)'!C13,'Regulation 28 calculator (rand)'!C14,'Regulation 28 calculator (rand)'!C15,'Regulation 28 calculator (rand)'!C16,'Regulation 28 calculator (rand)'!C17,'Regulation 28 calculator (rand)'!C18,'Regulation 28 calculator (rand)'!C19,'Regulation 28 calculator (rand)'!C20)>\"\",\"rand\",\"none\"))","v":"none"}]
[]
[null,null,"Unit trust name","Regulation 28 compliant","Equity","Property","Foreign"]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C7,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C7,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C7,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C7,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C5<>\"\",IF(VLOOKUP($C5,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E5<>\"\",VLOOKUP($C5,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C8,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C8,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C8,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C8,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C6<>\"\",IF(VLOOKUP($C6,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E6<>\"\",VLOOKUP($C6,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C9,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C9,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C9,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C9,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C7<>\"\",IF(VLOOKUP($C7,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E7<>\"\",VLOOKUP($C7,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C10,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C10,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C10,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C10,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C8<>\"\",IF(VLOOKUP($C8,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E8<>\"\",VLOOKUP($C8,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C11,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C11,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C11,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C11,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C9<>\"\",IF(VLOOKUP($C9,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E9<>\"\",VLOOKUP($C9,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C12,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C12,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C12,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C12,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C10<>\"\",IF(VLOOKUP($C10,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E10<>\"\",VLOOKUP($C10,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C13,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C13,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C13,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C13,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C11<>\"\",IF(VLOOKUP($C11,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E11<>\"\",VLOOKUP($C11,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C14,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C14,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C14,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C14,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C12<>\"\",IF(VLOOKUP($C12,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E12<>\"\",VLOOKUP($C12,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C15,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C15,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C15,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C15,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C13<>\"\",IF(VLOOKUP($C13,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E13<>\"\",VLOOKUP($C13,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C16,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C16,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C16,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C16,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C14<>\"\",IF(VLOOKUP($C14,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E14<>\"\",VLOOKUP($C14,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C17,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C17,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C17,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C17,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C15<>\"\",IF(VLOOKUP($C15,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E15<>\"\",VLOOKUP($C15,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C18,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C18,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C18,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C18,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C16<>\"\",IF(VLOOKUP($C16,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E16<>\"\",VLOOKUP($C16,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C19,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C19,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C19,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C19,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C17<>\"\",IF(VLOOKUP($C17,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E17<>\"\",VLOOKUP($C17,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[null,null,{"$f":"IF($D$2=\"percent\",\n  IF(ISERROR(VLOOKUP('Regulation 28 calculator (%)'!C20,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (%)'!C20,'Fund list'!A:A,1,FALSE)),\n  IF($D$2=\"rand\",\n   IF(ISERROR(VLOOKUP('Regulation 28 calculator (rand)'!C20,'Fund list'!A:A,1,FALSE)),\"\",VLOOKUP('Regulation 28 calculator (rand)'!C20,'Fund list'!A:A,1,FALSE)),\n   \"\"))","v":""},{"$f":"IF(C18<>\"\",IF(VLOOKUP($C18,'Fund list'!$A:$I,MATCH(D$4,'Fund list'!$A$5:$I$5,0),FALSE)=\"Yes\",\"Yes\",\"No\"),\"\")","v":""},{"$f":"IF(C18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(E$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(D18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(F$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""},{"$f":"IF(E18<>\"\",VLOOKUP($C18,'Fund list'!$A:$I,MATCH(G$4,'Fund list'!$A$5:$I$5,0),FALSE),\"\")","v":""}]
[]
[null,null,"The information shown is the latest information provided by the relevant unit trust management companies and is based on a combination of their respective investment mandates and past practices, as well as on the best understanding of the regulations. This information may therefore be subject to change. "]
[]
[null,null,"Asset allocation last updated:","2025-04-25T08:38:02"]
[null,null,{"$f":"\"The above funds are those chosen in the \"&IF(D2=\"percent\",\"'Regulation 28 calculator (%)'\",\"'Regulation 28 calculator (rand)'\")&\" tab.\"","v":"The above funds are those chosen in the 'Regulation 28 calculator (rand)' tab."}]
[]
[null,null,{"$f":"\"Click on the \"&IF(D2=\"percent\",\"'Regulation 28 calculator (%)'\",\"'Regulation 28 calculator (rand)'\")&\" tab at the bottom to go back to the Regulation 28 calculator.\"","v":"Click on the 'Regulation 28 calculator (rand)' tab at the bottom to go back to the Regulation 28 calculator."}]

{"sheet":"Fund list","index":7,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[4,6,4,8]]}
[]
[]
[]
["Public Funds - Intended Maximum Limits"]
["Fund name","Fund code","Regulation 28 compliant","Equity","Property","Foreign"]
["Allan Gray Equity Fund","AGEF","No",0.95599999999999996,1.3100000000000001E-2,0.43540000000000001]
["Allan Gray Balanced Fund","AGBF","Yes",0.66859999999999997,8.8000000000000005E-3,0.37319999999999998]
["Allan Gray Stable Fund","AGSF","Yes",0.2707,7.6E-3,0.29060000000000002,null,null,null,null," "]
["Allan Gray Interest Fund","AGIFA","Yes",0,0,0]
["Allan Gray - Orbis Global Equity Feeder Fund","AGOE","No",0.96150000000000002,9.7999999999999997E-3,0.99629999999999996]
["Allan Gray - Orbis Global Balanced Feeder Fund","AGGF","No",0.61519999999999997,5.0000000000000001E-3,0.99509999999999998]
["Allan Gray SA Equity Fund","AGDA","No",0.9839,8.0999999999999996E-3,0]
["Allan Gray Optimal Fund","AGOF","No",3.6600000000000001E-2,0,0]
["Allan Gray Bond Fund","AGBD","Yes",0,0,0]
["Allan Gray Income Fund","AGINA","Yes",0,0,0]
["Allan Gray Money Market Fund","AGMF","Yes",0,0,0]
["Allan Gray - Orbis Global Optimal Fund of Funds","AGOO","No",4.8300000000000003E-2,4.6899999999999997E-2,0.99280000000000002]
["Coronation Global Capital Plus [ZAR] Feeder Fund (Class P)","CGCB4","No",0.2535,2.3900000000000001E-2,0.995]
["Coronation Global Managed [ZAR] Feeder Fund (Class P)","CGMB4","No",0.69030000000000002,2.0400000000000001E-2,0.99690000000000001]
["Coronation Global Equity Select [ZAR] Feeder Fund (Class P)","CGEFP","No",0.98140000000000005,0,0.98740000000000006]
["Camissa Stable Fund (Class B)","KASCB","Yes",0.38200000000000001,3.6999999999999998E-2,0.157]
["Catalyst SCI Global Real Estate Feeder Fund (Class B)","CGRE","No",0,0.99509999999999998,0.99509999999999998]
["Coronation Global Optimum Growth [ZAR] Feeder Fund (Class P)","COGFB4","No",0.7772,4.7999999999999996E-3,0.95199999999999996]
["Nedgroup Investments Flexible Income Fund (Class B1)","NEIFB","Yes",2.63E-2,1.6500000000000001E-2,0.1323]
["Nedgroup Investments Global Flexible Feeder Fund (Class B2)","NEIG","No",0.55600000000000005,1.2E-2,1]
["Old Mutual Global Equity Fund (Class B1)","OMGB1","No",0.93669999999999998,0,0.94810000000000005]
["Foord Balanced Fund (Class B2)","FBCB2","Yes",0.67879999999999996,3.09E-2,0.39119999999999999]
["Nedgroup Investments Core Guarded Fund (Class B2)","NICGF","Yes",0.37790000000000001,3.8600000000000002E-2,0.2742]
["Coronation Balanced Defensive Fund (Class P)","CBDB4","Yes",0.40300000000000002,1.7999999999999999E-2,0.35399999999999998]
["Coronation Market Plus Fund (Class P)","CMPL4","No",0.70899999999999996,8.5000000000000006E-2,0.40100000000000002]
["Nedgroup Investments Balanced Fund (Class G)","TMBFG","Yes",0.68540000000000001,4.2200000000000001E-2,0.30470000000000003]
["Nedgroup Investments Core Diversified Fund (Class B2)","NICDF","Yes",0.70499999999999996,3.95E-2,0.38119999999999998]
["Coronation Balanced Plus Fund (Class P)","CBFB4","Yes",0.72309999999999997,5.3499999999999999E-2,0.43219999999999997]
["Coronation Global Emerging Markets Flexible [ZAR] Fund (Class P)","CGEMB4","No",0.98770000000000002,6.9999999999999999E-4,0.97399999999999998]
["Coronation Top 20 Fund (Class P)","CTTB4","No",0.99890000000000001,0,0]
["Fairtree SA Equity Prescient Fund (Class P1)","FEPP1","No",0.96889999999999998,1.5100000000000001E-2,0]
["Foord Flexible Fund of Funds (Class B2)","FFCB2","No",0.71589999999999998,2.1600000000000001E-2,0.65280000000000005]
["M&G Inflation Plus Fund (Class B)","PRCB","Yes",0.36899999999999999,4.4999999999999998E-2,0.23599999999999999]
["Nedgroup Investments Global Cautious Feeder Fund (Class B2)","NEGC","No",0.20469999999999999,0,1]
["Nedgroup Investments Opportunity Fund (Class B2)","NIOB","Yes",0.56920000000000004,3.9300000000000002E-2,0.2651]
["Ninety One Global Strategic Managed Feeder Fund (Class H)","GBFH","No",0.72099999999999997,7.0000000000000001E-3,0.99]
["Nedgroup Investments Global Equity Feeder Fund (Class B2)","GEFF","No",0.92769999999999997,0,1]
["Ninety One Diversified Income Fund (Class H)","IDICH","Yes",0,3.1E-2,0.123]
["Ninety One Opportunity Fund (Class E)","OPPE","Yes",0.58899999999999997,1.4E-2,0.38200000000000001]
["PSG Equity Fund (Class E)","PEFE","No",0.98299999999999998,1.4999999999999999E-2,0.27200000000000002]
["Ninety One Equity Fund (Class E)","EQTE","No",0.95499999999999996,3.2000000000000001E-2,0.34399999999999997]
["Prescient Balanced Fund (Class A2)","PRBA2","Yes",0.68630000000000002,4.9599999999999998E-2,0.44850000000000001]
["Satrix ALSI Index Fund (Class B1)","STAB1","No",0.99750000000000005,0,0]
["Sesfikile BCI Property Fund (Class B2)","SSPB2","No",0,0.9768,0]
["BCI Lindsell Train Global Equity Feeder Fund (Class A)","BLTGFA","No",0.98829999999999996,0,0.99970000000000003]
["Camissa Equity Alpha Fund (Class B1)","KEAB1","No",0.98299999999999998,1.4999999999999999E-2,0.13100000000000001]
["Camissa Islamic Balanced Fund (Class B)","KAICB","Yes",0.64500000000000002,2E-3,0.312]
["Camissa Balanced Fund (Class B)","KABCB","Yes",0.70299999999999996,1.4E-2,0.38700000000000001]
["Camissa Islamic Equity Fund (Class B)","KIECB","No",0.91600000000000004,0,0.33100000000000002]
["Coronation Strategic Income Fund (Class P)","CSIB4","Yes",1.4E-3,2.2599999999999999E-2,0.1135]
["Foord International Feeder Fund (Class B2)","FIFB2","No",0.52510000000000001,3.9600000000000003E-2,1]
["Satrix MSCI World Index Fund (Class B2)","SWEB2","No",0.98780000000000001,8.3000000000000001E-3,0.998]
["M&G Balanced Fund (Class B)","PRAB","Yes",0.66,3.3000000000000002E-2,0.312]
["M&G Equity Fund (Class B)","PEFB","No",0.98299999999999998,1.6E-2,0.22900000000000001]
["PSG Flexible Fund (Class E)","PFFE","No",0.89300000000000002,1.6E-2,0.29199999999999998]
["Mazi Asset Management Prime Equity Fund (Class B2)","MCEFB2","No",0.94428199999999995,5.0182999999999998E-2,1.5999999999999999E-5]
["Nedgroup Investments Core Global Feeder Fund (Class A)","NIGFCA","No",0.69989999999999997,3.5299999999999998E-2,0.99529999999999996]
["Nedgroup Investments Stable Fund (Class A2)","NISA","Yes",0.43990000000000001,4.1599999999999998E-2,0.45]
["Ninety One Cautious Managed Fund (Class H)","CMFH","Yes",0.17299999999999999,0,0.26300000000000001]
["Ninety One Global Franchise Feeder Fund (Class H)","GLOH","No",0.98599999999999999,0,0.996]
["Prescient Income Provider Fund (Class A2)","PIPFB5","Yes",1.8700000000000001E-2,2.7000000000000001E-3,5.9499999999999997E-2]
["PSG Balanced Fund (Class E)","PBFE","Yes",0.70299999999999996,3.6999999999999998E-2,0.34599999999999997]
["Rezco Value Trend Fund (Class C1)","RVTC1","Yes",0.63900000000000001,0,0.184]
["Perpetua SCI Equity Fund (Class E)","PMECE","No",0.99339999999999995,0,0]
["27four Shari'ah Balanced Fund of Funds (Class A4)","SBPA4","Yes",0.70269999999999999,0,0.31719999999999998]
["BCI Fundsmith Equity Feeder Fund (Class A)","BFEFA","No",0.97789999999999999,0,0.99919999999999998]
["Coronation Capital Plus Fund (Class P)","CCPB5","Yes",0.61180000000000001,1.6799999999999999E-2,0.4017]
["Coronation Global Strategic USD Income [ZAR] Feeder Fund (Class P)","CGSIF","No",1.8E-3,1.4800000000000001E-2,0.97699999999999998]
["Ninety One Managed Fund (Class E)","MTBTE","Yes",0.63200000000000001,0,0.45]